﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSetRpt" targetNamespace="http://tempuri.org/DataSetRpt.xsd" xmlns:mstns="http://tempuri.org/DataSetRpt.xsd" xmlns="http://tempuri.org/DataSetRpt.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Data Source=117.103.192.18;Initial Catalog=QLCF;Persist Security Info=True;User ID=gocf;Password=admin123" IsAppSettingsProperty="false" Modifier="Assembly" Name="intecom-online.QLCF.dbo" ParameterPrefix="@" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="uspBillDetailGetByBillIDTableAdapter" GeneratorDataComponentClassName="uspBillDetailGetByBillIDTableAdapter" Name="uspBillDetailGetByBillID" UserDataComponentName="uspBillDetailGetByBillIDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="intecom-online.QLCF.dbo" DbObjectName="QLCF.dbo.uspBillDetailGetByBillID" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.uspBillDetailGetByBillID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@BillID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BillDetailID" DataSetColumn="BillDetailID" />
              <Mapping SourceColumn="BillID" DataSetColumn="BillID" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="ProductCode" DataSetColumn="ProductCode" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="IsQuantification" DataSetColumn="IsQuantification" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="PriceName" DataSetColumn="PriceName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="uspBillGetReportTableAdapter" GeneratorDataComponentClassName="uspBillGetReportTableAdapter" Name="uspBillGetReport" UserDataComponentName="uspBillGetReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="intecom-online.QLCF.dbo" DbObjectName="QLCF.dbo.uspBillGetReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.uspBillGetReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fromDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@toDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@adminID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="InputOutput" ParameterName="@SumMoneyAll" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="InputOutput" ParameterName="@PriceServicesAll" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="InputOutput" ParameterName="@PromotionMoneyAll" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="InputOutput" ParameterName="@TotalMoneyAll" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RowNumber" DataSetColumn="RowNumber" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="TableName" DataSetColumn="TableName" />
              <Mapping SourceColumn="BillID" DataSetColumn="BillID" />
              <Mapping SourceColumn="SumMoney" DataSetColumn="SumMoney" />
              <Mapping SourceColumn="SumMoneyName" DataSetColumn="SumMoneyName" />
              <Mapping SourceColumn="PriceServices" DataSetColumn="PriceServices" />
              <Mapping SourceColumn="PriceServicesName" DataSetColumn="PriceServicesName" />
              <Mapping SourceColumn="PromotionMoney" DataSetColumn="PromotionMoney" />
              <Mapping SourceColumn="PromotionMoneyName" DataSetColumn="PromotionMoneyName" />
              <Mapping SourceColumn="TotalMoney" DataSetColumn="TotalMoney" />
              <Mapping SourceColumn="TotalMoneyName" DataSetColumn="TotalMoneyName" />
              <Mapping SourceColumn="StartTime" DataSetColumn="StartTime" />
              <Mapping SourceColumn="EndTime" DataSetColumn="EndTime" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="uspStockReportAllSearchTableAdapter" GeneratorDataComponentClassName="uspStockReportAllSearchTableAdapter" Name="uspStockReportAllSearch" UserDataComponentName="uspStockReportAllSearchTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="intecom-online.QLCF.dbo" DbObjectName="QLCF.dbo.uspStockReportAllSearch" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.uspStockReportAllSearch</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@productName" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@categoryID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="CurrentQuantity" DataSetColumn="CurrentQuantity" />
              <Mapping SourceColumn="CurrentQuantityName" DataSetColumn="CurrentQuantityName" />
              <Mapping SourceColumn="TotalStock" DataSetColumn="TotalStock" />
              <Mapping SourceColumn="TotalStockName" DataSetColumn="TotalStockName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="uspStockGetAllSearchTableAdapter" GeneratorDataComponentClassName="uspStockGetAllSearchTableAdapter" Name="uspStockGetAllSearch" UserDataComponentName="uspStockGetAllSearchTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="intecom-online.QLCF.dbo" DbObjectName="QLCF.dbo.uspStockGetAllSearch" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.uspStockGetAllSearch</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fromDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@toDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@adminID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="InputOutput" ParameterName="@totalMoney" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StockID" DataSetColumn="StockID" />
              <Mapping SourceColumn="TotalMoney" DataSetColumn="TotalMoney" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="DistributeID" DataSetColumn="DistributeID" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="PriceName" DataSetColumn="PriceName" />
              <Mapping SourceColumn="DistributeName" DataSetColumn="DistributeName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="uspStockDetailGetAllByStockIDTableAdapter" GeneratorDataComponentClassName="uspStockDetailGetAllByStockIDTableAdapter" Name="uspStockDetailGetAllByStockID" UserDataComponentName="uspStockDetailGetAllByStockIDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="intecom-online.QLCF.dbo" DbObjectName="QLCF.dbo.uspStockDetailGetAllByStockID" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.uspStockDetailGetAllByStockID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StockID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="InputOutput" ParameterName="@totalMoney" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StockDetailID" DataSetColumn="StockDetailID" />
              <Mapping SourceColumn="StockID" DataSetColumn="StockID" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="UnitID" DataSetColumn="UnitID" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="PriceName" DataSetColumn="PriceName" />
              <Mapping SourceColumn="TotalMoney" DataSetColumn="TotalMoney" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSetRpt" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSetRpt" msprop:Generator_UserDSName="DataSetRpt">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="uspBillDetailGetByBillID" msprop:Generator_TableClassName="uspBillDetailGetByBillIDDataTable" msprop:Generator_TableVarName="tableuspBillDetailGetByBillID" msprop:Generator_TablePropName="uspBillDetailGetByBillID" msprop:Generator_RowDeletingName="uspBillDetailGetByBillIDRowDeleting" msprop:Generator_UserTableName="uspBillDetailGetByBillID" msprop:Generator_RowChangingName="uspBillDetailGetByBillIDRowChanging" msprop:Generator_RowEvHandlerName="uspBillDetailGetByBillIDRowChangeEventHandler" msprop:Generator_RowDeletedName="uspBillDetailGetByBillIDRowDeleted" msprop:Generator_RowEvArgName="uspBillDetailGetByBillIDRowChangeEvent" msprop:Generator_RowChangedName="uspBillDetailGetByBillIDRowChanged" msprop:Generator_RowClassName="uspBillDetailGetByBillIDRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillDetailID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnBillDetailID" msprop:Generator_ColumnPropNameInRow="BillDetailID" msprop:Generator_ColumnPropNameInTable="BillDetailIDColumn" msprop:Generator_UserColumnName="BillDetailID" type="xs:int" />
              <xs:element name="BillID" msprop:Generator_ColumnVarNameInTable="columnBillID" msprop:Generator_ColumnPropNameInRow="BillID" msprop:Generator_ColumnPropNameInTable="BillIDColumn" msprop:Generator_UserColumnName="BillID" type="xs:int" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="ProductCode" msprop:Generator_ColumnVarNameInTable="columnProductCode" msprop:Generator_ColumnPropNameInRow="ProductCode" msprop:Generator_ColumnPropNameInTable="ProductCodeColumn" msprop:Generator_UserColumnName="ProductCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:double" />
              <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:int" />
              <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsQuantification" msprop:Generator_ColumnVarNameInTable="columnIsQuantification" msprop:Generator_ColumnPropNameInRow="IsQuantification" msprop:Generator_ColumnPropNameInTable="IsQuantificationColumn" msprop:Generator_UserColumnName="IsQuantification" type="xs:boolean" minOccurs="0" />
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPriceName" msprop:Generator_ColumnPropNameInRow="PriceName" msprop:Generator_ColumnPropNameInTable="PriceNameColumn" msprop:Generator_UserColumnName="PriceName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="uspBillGetReport" msprop:Generator_TableClassName="uspBillGetReportDataTable" msprop:Generator_TableVarName="tableuspBillGetReport" msprop:Generator_TablePropName="uspBillGetReport" msprop:Generator_RowDeletingName="uspBillGetReportRowDeleting" msprop:Generator_UserTableName="uspBillGetReport" msprop:Generator_RowChangingName="uspBillGetReportRowChanging" msprop:Generator_RowEvHandlerName="uspBillGetReportRowChangeEventHandler" msprop:Generator_RowDeletedName="uspBillGetReportRowDeleted" msprop:Generator_RowEvArgName="uspBillGetReportRowChangeEvent" msprop:Generator_RowChangedName="uspBillGetReportRowChanged" msprop:Generator_RowClassName="uspBillGetReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RowNumber" msprop:Generator_ColumnVarNameInTable="columnRowNumber" msprop:Generator_ColumnPropNameInRow="RowNumber" msprop:Generator_ColumnPropNameInTable="RowNumberColumn" msprop:Generator_UserColumnName="RowNumber" type="xs:int" minOccurs="0" />
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TableName" msprop:Generator_ColumnVarNameInTable="columnTableName" msprop:Generator_ColumnPropNameInRow="TableName" msprop:Generator_ColumnPropNameInTable="TableNameColumn" msprop:Generator_UserColumnName="TableName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillID" msprop:Generator_ColumnVarNameInTable="columnBillID" msprop:Generator_ColumnPropNameInRow="BillID" msprop:Generator_ColumnPropNameInTable="BillIDColumn" msprop:Generator_UserColumnName="BillID" type="xs:int" minOccurs="0" />
              <xs:element name="SumMoney" msprop:Generator_ColumnVarNameInTable="columnSumMoney" msprop:Generator_ColumnPropNameInRow="SumMoney" msprop:Generator_ColumnPropNameInTable="SumMoneyColumn" msprop:Generator_UserColumnName="SumMoney" type="xs:int" minOccurs="0" />
              <xs:element name="SumMoneyName" msprop:Generator_ColumnVarNameInTable="columnSumMoneyName" msprop:Generator_ColumnPropNameInRow="SumMoneyName" msprop:Generator_ColumnPropNameInTable="SumMoneyNameColumn" msprop:Generator_UserColumnName="SumMoneyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceServices" msprop:Generator_ColumnVarNameInTable="columnPriceServices" msprop:Generator_ColumnPropNameInRow="PriceServices" msprop:Generator_ColumnPropNameInTable="PriceServicesColumn" msprop:Generator_UserColumnName="PriceServices" type="xs:int" minOccurs="0" />
              <xs:element name="PriceServicesName" msprop:Generator_ColumnVarNameInTable="columnPriceServicesName" msprop:Generator_ColumnPropNameInRow="PriceServicesName" msprop:Generator_ColumnPropNameInTable="PriceServicesNameColumn" msprop:Generator_UserColumnName="PriceServicesName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PromotionMoney" msprop:Generator_ColumnVarNameInTable="columnPromotionMoney" msprop:Generator_ColumnPropNameInRow="PromotionMoney" msprop:Generator_ColumnPropNameInTable="PromotionMoneyColumn" msprop:Generator_UserColumnName="PromotionMoney" type="xs:int" minOccurs="0" />
              <xs:element name="PromotionMoneyName" msprop:Generator_ColumnVarNameInTable="columnPromotionMoneyName" msprop:Generator_ColumnPropNameInRow="PromotionMoneyName" msprop:Generator_ColumnPropNameInTable="PromotionMoneyNameColumn" msprop:Generator_UserColumnName="PromotionMoneyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalMoney" msprop:Generator_ColumnVarNameInTable="columnTotalMoney" msprop:Generator_ColumnPropNameInRow="TotalMoney" msprop:Generator_ColumnPropNameInTable="TotalMoneyColumn" msprop:Generator_UserColumnName="TotalMoney" type="xs:int" minOccurs="0" />
              <xs:element name="TotalMoneyName" msprop:Generator_ColumnVarNameInTable="columnTotalMoneyName" msprop:Generator_ColumnPropNameInRow="TotalMoneyName" msprop:Generator_ColumnPropNameInTable="TotalMoneyNameColumn" msprop:Generator_UserColumnName="TotalMoneyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartTime" msprop:Generator_ColumnVarNameInTable="columnStartTime" msprop:Generator_ColumnPropNameInRow="StartTime" msprop:Generator_ColumnPropNameInTable="StartTimeColumn" msprop:Generator_UserColumnName="StartTime" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndTime" msprop:Generator_ColumnVarNameInTable="columnEndTime" msprop:Generator_ColumnPropNameInRow="EndTime" msprop:Generator_ColumnPropNameInTable="EndTimeColumn" msprop:Generator_UserColumnName="EndTime" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="uspStockReportAllSearch" msprop:Generator_TableClassName="uspStockReportAllSearchDataTable" msprop:Generator_TableVarName="tableuspStockReportAllSearch" msprop:Generator_TablePropName="uspStockReportAllSearch" msprop:Generator_RowDeletingName="uspStockReportAllSearchRowDeleting" msprop:Generator_UserTableName="uspStockReportAllSearch" msprop:Generator_RowChangingName="uspStockReportAllSearchRowChanging" msprop:Generator_RowEvHandlerName="uspStockReportAllSearchRowChangeEventHandler" msprop:Generator_RowDeletedName="uspStockReportAllSearchRowDeleted" msprop:Generator_RowEvArgName="uspStockReportAllSearchRowChangeEvent" msprop:Generator_RowChangedName="uspStockReportAllSearchRowChanged" msprop:Generator_RowClassName="uspStockReportAllSearchRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" minOccurs="0" />
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:int" minOccurs="0" />
              <xs:element name="CategoryName" msprop:Generator_ColumnVarNameInTable="columnCategoryName" msprop:Generator_ColumnPropNameInRow="CategoryName" msprop:Generator_ColumnPropNameInTable="CategoryNameColumn" msprop:Generator_UserColumnName="CategoryName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrentQuantity" msprop:Generator_ColumnVarNameInTable="columnCurrentQuantity" msprop:Generator_ColumnPropNameInRow="CurrentQuantity" msprop:Generator_ColumnPropNameInTable="CurrentQuantityColumn" msprop:Generator_UserColumnName="CurrentQuantity" type="xs:int" minOccurs="0" />
              <xs:element name="CurrentQuantityName" msprop:Generator_ColumnVarNameInTable="columnCurrentQuantityName" msprop:Generator_ColumnPropNameInRow="CurrentQuantityName" msprop:Generator_ColumnPropNameInTable="CurrentQuantityNameColumn" msprop:Generator_UserColumnName="CurrentQuantityName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalStock" msprop:Generator_ColumnVarNameInTable="columnTotalStock" msprop:Generator_ColumnPropNameInRow="TotalStock" msprop:Generator_ColumnPropNameInTable="TotalStockColumn" msprop:Generator_UserColumnName="TotalStock" type="xs:int" minOccurs="0" />
              <xs:element name="TotalStockName" msprop:Generator_ColumnVarNameInTable="columnTotalStockName" msprop:Generator_ColumnPropNameInRow="TotalStockName" msprop:Generator_ColumnPropNameInTable="TotalStockNameColumn" msprop:Generator_UserColumnName="TotalStockName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="uspStockGetAllSearch" msprop:Generator_TableClassName="uspStockGetAllSearchDataTable" msprop:Generator_TableVarName="tableuspStockGetAllSearch" msprop:Generator_TablePropName="uspStockGetAllSearch" msprop:Generator_RowDeletingName="uspStockGetAllSearchRowDeleting" msprop:Generator_UserTableName="uspStockGetAllSearch" msprop:Generator_RowChangingName="uspStockGetAllSearchRowChanging" msprop:Generator_RowEvHandlerName="uspStockGetAllSearchRowChangeEventHandler" msprop:Generator_RowDeletedName="uspStockGetAllSearchRowDeleted" msprop:Generator_RowEvArgName="uspStockGetAllSearchRowChangeEvent" msprop:Generator_RowChangedName="uspStockGetAllSearchRowChanged" msprop:Generator_RowClassName="uspStockGetAllSearchRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StockID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnStockID" msprop:Generator_ColumnPropNameInRow="StockID" msprop:Generator_ColumnPropNameInTable="StockIDColumn" msprop:Generator_UserColumnName="StockID" type="xs:int" />
              <xs:element name="TotalMoney" msprop:Generator_ColumnVarNameInTable="columnTotalMoney" msprop:Generator_ColumnPropNameInRow="TotalMoney" msprop:Generator_ColumnPropNameInTable="TotalMoneyColumn" msprop:Generator_UserColumnName="TotalMoney" type="xs:int" />
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
              <xs:element name="DistributeID" msprop:Generator_ColumnVarNameInTable="columnDistributeID" msprop:Generator_ColumnPropNameInRow="DistributeID" msprop:Generator_ColumnPropNameInTable="DistributeIDColumn" msprop:Generator_UserColumnName="DistributeID" type="xs:int" />
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:int" />
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPriceName" msprop:Generator_ColumnPropNameInRow="PriceName" msprop:Generator_ColumnPropNameInTable="PriceNameColumn" msprop:Generator_UserColumnName="PriceName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DistributeName" msprop:Generator_ColumnVarNameInTable="columnDistributeName" msprop:Generator_ColumnPropNameInRow="DistributeName" msprop:Generator_ColumnPropNameInTable="DistributeNameColumn" msprop:Generator_UserColumnName="DistributeName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="uspStockDetailGetAllByStockID" msprop:Generator_TableClassName="uspStockDetailGetAllByStockIDDataTable" msprop:Generator_TableVarName="tableuspStockDetailGetAllByStockID" msprop:Generator_TablePropName="uspStockDetailGetAllByStockID" msprop:Generator_RowDeletingName="uspStockDetailGetAllByStockIDRowDeleting" msprop:Generator_UserTableName="uspStockDetailGetAllByStockID" msprop:Generator_RowChangingName="uspStockDetailGetAllByStockIDRowChanging" msprop:Generator_RowEvHandlerName="uspStockDetailGetAllByStockIDRowChangeEventHandler" msprop:Generator_RowDeletedName="uspStockDetailGetAllByStockIDRowDeleted" msprop:Generator_RowEvArgName="uspStockDetailGetAllByStockIDRowChangeEvent" msprop:Generator_RowChangedName="uspStockDetailGetAllByStockIDRowChanged" msprop:Generator_RowClassName="uspStockDetailGetAllByStockIDRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StockDetailID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnStockDetailID" msprop:Generator_ColumnPropNameInRow="StockDetailID" msprop:Generator_ColumnPropNameInTable="StockDetailIDColumn" msprop:Generator_UserColumnName="StockDetailID" type="xs:int" />
              <xs:element name="StockID" msprop:Generator_ColumnVarNameInTable="columnStockID" msprop:Generator_ColumnPropNameInRow="StockID" msprop:Generator_ColumnPropNameInTable="StockIDColumn" msprop:Generator_UserColumnName="StockID" type="xs:int" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:double" />
              <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:int" />
              <xs:element name="UnitID" msprop:Generator_ColumnVarNameInTable="columnUnitID" msprop:Generator_ColumnPropNameInRow="UnitID" msprop:Generator_ColumnPropNameInTable="UnitIDColumn" msprop:Generator_UserColumnName="UnitID" type="xs:int" />
              <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="PriceName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPriceName" msprop:Generator_ColumnPropNameInRow="PriceName" msprop:Generator_ColumnPropNameInTable="PriceNameColumn" msprop:Generator_UserColumnName="PriceName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalMoney" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalMoney" msprop:Generator_ColumnPropNameInRow="TotalMoney" msprop:Generator_ColumnPropNameInTable="TotalMoneyColumn" msprop:Generator_UserColumnName="TotalMoney" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:uspBillDetailGetByBillID" />
      <xs:field xpath="mstns:BillDetailID" />
    </xs:unique>
    <xs:unique name="uspStockGetAllSearch_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:uspStockGetAllSearch" />
      <xs:field xpath="mstns:StockID" />
    </xs:unique>
    <xs:unique name="uspStockDetailGetAllByStockID_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:uspStockDetailGetAllByStockID" />
      <xs:field xpath="mstns:StockDetailID" />
    </xs:unique>
  </xs:element>
</xs:schema>